Oracle

The following table lists the data types that the ODBC driver supports for Oracle:

Table B-4. Mapping Data Types for Oracle to ODBC Data Types 
Oracle 9i Data Type
Oracle10g Data Type
ODBC Data Type
BFILE
BFILE
SQL_LONGVARBINARY
 
BINARY_FLOAT
SQL_REAL
 
BINARY_DOUBLE
SQL_DOUBLE
BLOB
BLOB
SQL_LONGVARBINARY
CHAR(size)
CHAR(size)
SQL_CHAR1
SQL_WCHAR2
CLOB
CLOB
SQL_LONGVARCHAR3
SQL_WLONGVARCHAR2
DATE
DATE
SQL_TYPE_TIMESTAMP
LONG
LONG
SQL_LONGVARCHAR1
SQL_WLONGVARCHAR2
LONG RAW
LONG RAW
SQL_LONGVARBINARY
NCHAR(size)
NCHAR(size)
SQL_CHAR4
SQL_WCHAR5
NCLOB
NCLOB
SQL_LONGVARCHAR4
SQL_WLONGVARCHAR5
NUMBER
NUMBER
SQL_FLOAT
NUMBER(p,s)
NUMBER(p,s)
SQL_DECIMAL
NVARCHAR2(size)
NVARCHAR2(size)
SQL_VARCHAR4
SQL_WVARCHAR5
RAW(size)
RAW(size)
SQL_VARBINARY
ROWID
ROWID
SQL_VARCHAR
TIMESTAMP
TIMESTAMP
SQL_TIMESTAMP6
SQL_CHAR7
TIMESTAMP WITH LOCAL TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
SQL_TYPE_TIMESTAMP6
SQL_CHAR7
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH TIME ZONE
SQL_TYPE_TIMESTAMP6, 8, 9
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH TIME ZONE
SQL_CHAR7, 8
VARCHAR2(size)
 
SQL_VARCHAR1
VARCHAR2(size)
 
SQL_WVARCHAR2
    1Not present when DataSourceReportChar=False, ServiceCodePage=Database and database character set is Unicode
    2Only present when ServiceCodePage=Database and database character set is Unicode
    3Not present when ServiceCodePage=Database and database character set is Unicode
    4Not present when ServiceCodePage=Database and database character set is Unicode
    5Only present when ServiceCodePage=Database and national character set is Unicode
    6Only present when DataSourceFetchTimestampAsString=False
    7Only present when DataSourceFetchTimestampAsString=True
    8Only present when DataSourceORAMapTSWTZ=True
    9The time zone value is not accessible (or can not be set). Instead, the client time zone is used either to pass to Oracle or to convert from the stored time zone value.